if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pages]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pages]
GO

CREATE TABLE [dbo].[pages] (
	[id] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[path] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[body] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[datetimecreated] [datetime] NOT NULL ,
	[author] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[version] [int] NOT NULL ,
	[summary] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

insert into pages(id, path, body, datetimecreated, author, version, summary) values('EE04D302-00F3-1F8D-A3CDC239FC957A6E', 'Main', 'Welcome to CanvasWiki. To begin editing content, simply click on the [b]edit this page[/b] link on the right.', '10/12/2005', 'Raymond Camden', '1', 'Initial')